package com.jr.dao.impl;

import com.jr.dao.DetailViewDao;
import com.jr.entity.DetailView;
import com.jr.util.DAO;

import java.util.List;

/**
 * @Function：
 * @Author 梁明哲
 * @Email 424577090@qq.com
 * @Package com.jr.dao.impl
 * @Project invoice
 * @Date 2023-02-26 15:08:35
 */
public class DetailViewDaoImpl extends DAO<DetailView> implements DetailViewDao {

    /**
     * 根据企业id查询视图信息
     * @param enterpriseId
     * @return
     * @throws Exception
     */
    @Override
    public List<DetailView> allDetail(Integer enterpriseId) throws Exception {
        String sql = "SELECT title,tax_no AS taxNo,email_detail,area,address_detail FROM detail WHERE enterprise_id=?";
        return getForList(sql,enterpriseId);
    }
}







